package com.tupu.mapper.dispatch;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tupu.entity.dispatch.StandardizationPoint;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDateTime;
import java.util.List;
import java.util.Map;

/**
 * @author 15702
 * @description 针对表【tb_standardization_point】的数据库操作Mapper
 * @createDate 2023-11-10 10:56:58
 * @Entity com.tupu.entity.dispatch.StandardizationPoint
 */
public interface StandardizationPointMapper extends BaseMapper<StandardizationPoint> {

    List<Map<String, Object>> pointTypePercentage(@Param("station") String station, @Param("messageType") String messageType, @Param("startTime") LocalDateTime startTime, @Param("endTime") LocalDateTime endTime);

    List<Map<String, Object>> resultPercentage(@Param("station") String station, @Param("messageType") String messageType, @Param("startTime") LocalDateTime startTime, @Param("endTime") LocalDateTime endTime);

    List<Integer> selectStationNo();

    List<String> selectPointNameByStationNo(Integer id);

    @Select("SELECT * FROM tb_standardization_point WHERE standard_id IS NULL;")
    List<StandardizationPoint> selectStandardIdNull();
}




